Logbook Dashboard – Completion Time

The Completion Time dashboard provides analysis of average completion time and on time/overdue analysis relative to Service Level Agreements (SLA).

Specify any of the following criteria to filter the information displayed and then click FIND.

• Region – Select a value to only include data for a particular region.

• Property – Click the Select link to only include data for a particular property.

• Activity – Select a value to only include data for work types/subTypes within a particular activity group.

• Request Date Range – Enter two date values to only include data for work orders that were created within the specified date range.

• Actual Completion Date Range – Enter two date values to only include data for work orders that were completed within the specified date range.

The Average Completion Time

This pane displays average completion time for work orders in both graphical and tabular formats. The average completion time is calculated using the following formula:

AVG Completion Time in Days = Total Completion Time / (Total Property Hours per Day * 60)

where:

Total Completion Time = the sum of the actual completion times for all requests that fall within the specified date range, in minutes

Total Property Hours per Day = the sum of the SLA service hours currently in place for the properties where each request occurred, in hours

Clicking a number in the Count column displays all the associated work requests.

The SLA Completion Time – Analysis (Complete Work Orders Only)

This pane displays a series of graphs and data points indicating on time and overdue statistics for work requests as they relate to the Estimated SLA Completion date on work orders.

The data only represents completed work orders that have an estimated SLA Completion date and does not represent on time or overdue statistics related to SLA Response.

• SLA Totals – Pie Chart graph of on time and overdue work requests based on the Estimated SLA completion at the work order level.

• SLA by Priority – Bar chart of on time and overdue work orders by priority.

• Table – Displays in table format the priority and counts of the following work orders:

  • Overdue – Complete date is greater than the estimated SLA completion date.
  • On Time – Complete date is less than the estimated SLA completion date.
  • No SLA – Have no estimated SLA Completion date (configuration option).
  • Excluded – Requests can be excluded for a variety of reasons such as being completed before they are scheduled, being put into an On Hold status, or having an origination code that is excluded from reports. These values are configured on the Logbook Configuration page, within the following settings: Include WOs where Complete Date <=Scheduled Date and Calc SLA Using On Hold. Each number can be selected to drill down into the specific work requests.